Filter Data

Ex-Online has several filter functions that can be applied to each heading. All headings can have filters on concurrently, although only one filter can be applied per heading. When multiple filters are used simultaneously the results shown are the logical AND of all active filters. There are five types of filters that can be applied to a heading, these are: Contains, Does not contain, Starts with, Is empty and Is not empty. Additionally there is a unique filter option that will show only selected items. These filters will be introduced in the following sections

Introduction to the Filter Bar

The Filter Bar is a graphical representation of applied filters in both active and inactive states. The user can toggle each individual filters active status by clicking on it, or remove it completely by clicking the cross on the right hand side.

The filter bar is shown here with three applied filters. The first filter is applied to the tag numbers heading; TAG_NO, it is a contain filter and is looking for the string “JB” in the tag numbers of every item. The second filter is applied to the area heading; AREA, it is a contain filter and is looking for the character ‘1’ in the areas of each item. The third filter is applied to the last inspection date heading; LAST_INSP_DATE, it is an “is not empty” filter and it is looking at the last inspection date of all items and returning those that have an inspection date listed. The “is not empty” filter is greyed out signifying that it is currently inactive.

Contains

The “Contains” filter will return all items that contain the specified string in the selected field. This filter requires an input in the text field

Does not contain

The “Does not contain” filter will return all items that do not contain the specified string in the selected field. This filter requires an input in the text field

Starts with

The “Starts with” filter will return all items that start with the specified string in the selected field. This filter requires an input in the text field

Is empty

The “Is empty” filter will return all items where the selected field is empty. This filter does not accept an input in the text field

Is not empty

The “Is not empty” filter will return all items where the selected field is not empty. This filter does not accept an input in the text field

Show Selection

The “Show Selection” filter will return all items that have been selected by the user in the tag browser. This filter is applied through the Show Selection button and is not associated with specific fields like the other filters.